const sqlTemplate = {
    idx_2: "GRANT INSERT ON dict.elot_tenant_pay_info TO 'elot'@'%';\nGRANT INSERT,UPDATE ON dict.payconfig TO 'elot'@'%';\nFLUSH PRIVILEGES;",
    idx_3: "REVOKE INSERT ON dict.elot_tenant_pay_info FROM 'elot'@'%';\nREVOKE INSERT,UPDATE ON dict.payconfig FROM 'elot'@'%';\nFLUSH PRIVILEGES;",

    idx_7: "SELECT * FROM information_schema.processlist a WHERE a.COMMAND != 'Sleep' and info is not null and time > 1 ORDER BY a.TIME DESC;",

    idx_1: "ALTER USER 'elot'@'localhost' IDENTIFIED BY '';",
    idx_4: "GRANT ALL PRIVILEGES ON *.* TO 'elot'@'%';\nFLUSH PRIVILEGES;",

    idx_5: "SHOW GRANTS FOR 'elot'",
    // idx_6: "SHOW SLAVE STATUS \\G;",
    idx_6: "SELECT A.MAX_CONNECTIONS 最大连接数, B.CONNECTION_COUNT 当前连接数 FROM (SELECT VARIABLE_VALUE AS MAX_CONNECTIONS FROM performance_schema.global_variables WHERE VARIABLE_NAME='max_connections') A, (SELECT COUNT(*) AS CONNECTION_COUNT FROM performance_schema.threads WHERE PROCESSLIST_ID IS NOT NULL) B;",

    idx_8: "select table_schema as '数据库',sum(table_rows) as '记录数', sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)', sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)' from information_schema.tables group by table_schema order by sum(data_length) desc, sum(index_length) desc;",
    idx_9: "select case d.trx_id when d.blocking_trx_id then d.id end as thread, d.ID id,d.db,d.TIME,d.trx_id,d.blocking_trx_id,d.Info from (select c.ID,c.db,c.TIME,a.trx_id,b.blocking_trx_id,c.Info from information_schema.INNODB_TRX a,(select min(blocking_trx_id) blocking_trx_id,requesting_trx_id from information_schema.INNODB_LOCK_WAITS group by requesting_trx_id) b, information_schema.PROCESSLIST c where a.trx_id=b.requesting_trx_id  and a.trx_mysql_thread_id=c.id union all select distinct c.ID,c.db,c.TIME,a.trx_id,b.blocking_trx_id,c.Info from information_schema.INNODB_TRX a,(select min(blocking_trx_id) blocking_trx_id,requesting_trx_id from information_schema.INNODB_LOCK_WAITS group by requesting_trx_id) b, information_schema.PROCESSLIST c where a.trx_id=b.blocking_trx_id  and a.trx_mysql_thread_id=c.id )d order by blocking_trx_id,id;",

    idx_10: "SHOW INDEX FROM db.table;",
    idx_11: "CREATE INDEX idx_name ON db.table(col);",
    idx_12: "SHOW CREATE TABLE db.table;",

    idx_13: "sudo -i;\nls -l /mybackup/audit_log/;\ngrep '' /mybackup/audit_log/server_audit.log;\nexit;",
    idx_14: "SHOW VARIABLES LIKE '%audit%'",

    idx_16: "SELECT * FROM WHERE = ",

    idx_17: "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'acct' and TABLE_NAME like '%%';",

    idx_18: "GRANT UPDATE ON message.elot_bulletin TO 'elot'@'%';\nFLUSH PRIVILEGES;",
    idx_19: "REVOKE UPDATE ON message.elot_bulletin FROM 'elot'@'%';\nFLUSH PRIVILEGES;",

}
